﻿CREATE TABLE [Person].[StateProvince] (
    [Id]                      INT           IDENTITY (1, 1) NOT NULL,
    [StateProvinceCode]       NCHAR (3)     NOT NULL,
    [CountryRegionCode]       NVARCHAR (3)  NOT NULL,
    [IsOnlyStateProvinceFlag] BIT           NOT NULL,
    [Name]                    NVARCHAR (50) NOT NULL,
    [ModifiedDate]            DATETIME      NOT NULL
);

